/**
 * 
 */
package com.feib.stms.dao;

import java.util.Date;
import java.util.List;

import com.feib.stms.dao.jdbc.SqlQueryMapProvider;
import com.feib.stms.model.DeliveryPayment;
import com.feib.stms.model.DeliveryPaymentSum;
import com.feib.stms.pagination.PaginatedList;

/**
 * @author Jeff Gu
 *
 */
public interface DeliveryPaymentSumDao {
	
	public int deleteByTempUploadFilePk(Long pk);

	public PaginatedList<DeliveryPaymentSum> findPaginatedListByPaymentFileContent(
			DeliveryPayment entity, Date deliveryDateFrom,
			Date deliveryDateTo, String amountStatus,
			List<String> constrainSecuritiesNos,
			PaginatedList<DeliveryPaymentSum> paginatedList);
	
	public SqlQueryMapProvider getSqlQueryMapProviderByPaymentFileContent(
			DeliveryPayment entity, Date deliveryDateFrom,
			Date deliveryDateTo, String amountStatus,
			List<String> constrainSecuritiesNos,
			PaginatedList<DeliveryPaymentSum> paginatedList);

}
